This MS Excel tutorial provides everything from the basics to advanced-level topics that will help you learn Microsoft Excel and become a master in data analysis, and spreadsheet management.

Excel Basics

• Excel – Entering Values


• Excel – Moving Around


• Excel – Save Workbook


• Excel – Create Worksheet


• Excel – Copy Worksheet


• Excel – Hiding Worksheet


• Excel – Delete Worksheet


• Excel – Close Workbook


• Excel – Open Workbook


• Excel – Merge Workbooks


• Excel – File Password


• Excel – File Share


• Excel – Insert Data


• Excel – Select Data


• Excel – Delete Data


• Excel – Move Data


• Excel – Rows & Columns


• Excel – Copy & Paste


• Excel – Find & Replace


• Excel – Special Symbols


• Excel – Insert Comments


• Excel – Add Text Box


• Excel – Shapes


• Excel – Insert WordArt


• Excel – Undo Changes

Formatting Cells

• Excel – Setting Cell Type


• Excel – Move Or Copy Cells


• Excel – Add Cells


• Excel – Delete Cells


• Excel – Setting Fonts


• Excel – Text Decoration


• Excel – Rotate Cells


• Excel – Setting Colors


• Excel – Text Alignment


• Excel – Merge & Wrap


• Excel – Borders & Shades


• Excel – Apply Formatting

Formatting Worksheets

• Excel – Sheet Options


• Excel – Adjust Margins


• Excel – Page Orientation


• Excel – Header & Footer


• Excel – Insert Page Break


• Excel – Set Background


• Excel – Freeze Panes


• Excel – Conditional Format


• Excel – Highlight Cells Rules


• Excel – Data Bars

Working with Formula

• Excel – Formulas


• Excel – Creating Formulas


• Excel – Copying Formulas


• Excel – Formula Reference


• Excel – Relative Reference


• Excel – Absolute Reference


• Excel – Arithmetic Operators


• Excel – Parenthesis


• Excel – Using Functions


• Excel – BuitIn Functions


• Excel – Apply Formatting

Excel Formatting

• Excel – Formatting


• Excel – Format Painter


• Excel – Format Fonts


• Excel – Format Borders


• Excel – Format Numbers


• Excel – Format Grids


• Excel – Format Settings

Advanced Operations

• Excel – Data Filtering


• Excel – Data Sorting


• Excel – Using Ranges


• Excel – Data Validations


• Excel – Using Styles


• Excel – Using Themes


• Excel – Using Templates


• Excel – Workbook Security


• Excel – Data Tables


• Excel – Pivot Tables


• Excel – Simple Charts


• Excel – Pivot Charts


• Excel – Remove Duplicates